package com.bgIntlgn.client.entity.jishubu;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

@View(name = "LatestElementCataloge_View", sqlToCreate = "select element_catalogs.id as catalogeid, element_catalogs.parent_id as parentid, elements_view.id as elementid, elements_view.elementname as elementname, elements_view.typename as typename, es.uid as uid, "
		+ "es.valid as valid, materials.name as materialname, paper_view.paperno as paperno , implementMethod_view.name as implementmethodname "
		+ "from (element_subversions as es left outer join  paper_view on es.uid=paper_view.uid), element_catalogs, elements_view, implementMethod_view, materials "
		+ "where element_catalogs.parent_id is null and element_catalogs.uid=es.uid and elements_view.id=es.element_id and es.material_id=materials.id and  es.impl_method=implementMethod_view.id"
		+ " and es.create_time in (select max(create_time) "
		+ "from element_subversions group by  element_id)")
public class LatestElementCatalogeView implements Bean {
	
	private Long catalogeid;
	private Long parentid;

	private Long elementid;
	private String elementname;
	private String typename;
	private String uid;
	private boolean valid;
	private String materialname;
	private Long paperno;
	private String implementmethodname;

	public Long getCatalogeid() {
		return catalogeid;
	}

	public void setCatalogeid(Long catalogeid) {
		this.catalogeid = catalogeid;
	}

	public Long getParentid() {
		return parentid;
	}

	public void setParentid(Long parentid) {
		this.parentid = parentid;
	}

	public Long getElementid() {
		return elementid;
	}

	public void setElementid(Long elementid) {
		this.elementid = elementid;
	}

	public String getImplementmethodname() {
		return implementmethodname;
	}

	public void setImplementmethodname(String implementmethodname) {
		this.implementmethodname = implementmethodname;
	}

	public String getElementname() {
		return elementname;
	}

	public void setElementname(String elementname) {
		this.elementname = elementname;
	}

	public String getTypename() {
		return typename;
	}

	public void setTypename(String typename) {
		this.typename = typename;
	}

	public String getUid() {
		return uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}

	public boolean isValid() {
		return valid;
	}

	public void setValid(boolean valid) {
		this.valid = valid;
	}

	public String getMaterialname() {
		return materialname;
	}

	public void setMaterialname(String materialname) {
		this.materialname = materialname;
	}

	public Long getPaperno() {
		return paperno;
	}

	public void setPaperno(Long paperno) {
		this.paperno = paperno;
	}

}
